Run query with OLAP parameter from Workspace

To run query with OLAP parameter from Workspace (to check parameters definition):

 

·          Select Query name inside Workspace

·          Right click

·          Select Run with parameters from menu

 

 

Parameter replacement dialog will appear.

 

 

·          Check the box Enabled

·          Select Change

 

New form will appear:

 

 

Select tab Level to change level (in our case Half Year)

Select tab Members to select member(s)

Select Accept

 

 

Now:

 

·          Select Accept

 

New result form will appear:

 

 

 

The name of new object is Country-Products.Px.

 

THIS OBJECT DOES NOT CONTAIN PARAMETERS.

IF OBJECT HAS NAME WITH EXTENSION .Px IT DOES NOT CONTAIN PARAMETERS.